﻿<%@ Page Title="List Student" Language="C#" MasterPageFile="~/Manager/Manager.master" AutoEventWireup="true" CodeFile="ListStudent.aspx.cs" Inherits="Manager_ListStudent" %>
<%@ Register assembly="DevExpress.Web.ASPxGridView.v11.2, Version=11.2.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxGridView" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.ASPxEditors.v11.2, Version=11.2.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.ASPxGridView.v11.2.Export, Version=11.2.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxGridView.Export" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.ASPxEditors.v11.2, Version=11.2.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx1" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
    <style type="text/css">
        .style3
        {
            width: 48px;
        }
        .style4
        {
            width: 59px;
        }
        .style5
        {
            width: 46px;
        }
        .style6
        {
            width: 48px;
            height: 27px;
        }
        .style7
        {
            width: 59px;
            height: 27px;
        }
        .style8
        {
            width: 46px;
            height: 27px;
        }
        .style9
        {
            height: 27px;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
    <table style="width:100%;">
        <tr>
            <td class="style6">
                                <dx1:ASPxButton ID="btExportPDF" runat="server" 
                                    CssFilePath="~/App_Themes/DevEx/{0}/styles.css" CssPostfix="DevEx" 
                                    onclick="btExportPDF_Click" 
                                    SpriteCssFilePath="~/App_Themes/DevEx/{0}/sprite.css" Text="Export to PDF" 
                                    Width="129px">
                                </dx1:ASPxButton>
                            </td>
            <td class="style7">
                                <dx1:ASPxButton ID="btExportXLS" runat="server" 
                                    CssFilePath="~/App_Themes/DevEx/{0}/styles.css" CssPostfix="DevEx" 
                                    onclick="btExportXLS_Click" 
                                    SpriteCssFilePath="~/App_Themes/DevEx/{0}/sprite.css" Text="Export to XLS" 
                                    Width="128px">
                                </dx1:ASPxButton>
                            </td>
            <td class="style8">
                                <dx1:ASPxButton ID="btExportXLSX" runat="server" 
                                    CssFilePath="~/App_Themes/DevEx/{0}/styles.css" CssPostfix="DevEx" 
                                    onclick="btExportXLSX_Click" 
                                    SpriteCssFilePath="~/App_Themes/DevEx/{0}/sprite.css" 
                                    Text="Export to XLSX" Width="128px">
                                </dx1:ASPxButton>
                            </td>
            <td class="style9">
            </td>
        </tr>
        <tr>
            <td class="style3">
                &nbsp;</td>
            <td class="style4">
                &nbsp;</td>
            <td class="style5">
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
        </table>
    <dx:ASPxGridView ID="gvwstudent" runat="server" AutoGenerateColumns="False" 
        CssFilePath="~/App_Themes/DevEx/{0}/styles.css" CssPostfix="DevEx" 
        DataSourceID="Main" KeyFieldName="StudentID" Width="100%">
        <Columns>
            <dx:GridViewCommandColumn ShowSelectCheckbox="True" VisibleIndex="0">
                <ClearFilterButton Visible="True">
                </ClearFilterButton>
            </dx:GridViewCommandColumn>
            <dx:GridViewDataTextColumn FieldName="StudentID" ReadOnly="True" 
                VisibleIndex="1">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="Password" VisibleIndex="2" 
                Visible="False">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="Firstname" VisibleIndex="3">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="Lastname" VisibleIndex="4">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataComboBoxColumn FieldName="Gender" VisibleIndex="5">
                <PropertiesComboBox>
                    <Items>
                        <dx:ListEditItem Text=" Male" Value="Male" />
                        <dx:ListEditItem Text="Female" Value="Female" />
                    </Items>
                </PropertiesComboBox>
            </dx:GridViewDataComboBoxColumn>
            <dx:GridViewDataDateColumn FieldName="Birthdate" VisibleIndex="6">
            </dx:GridViewDataDateColumn>
            <dx:GridViewDataTextColumn FieldName="Address" VisibleIndex="7">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="Phone" VisibleIndex="8">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="Email" VisibleIndex="9">
            </dx:GridViewDataTextColumn>
        </Columns>
        <Settings ShowFilterRow="True" ShowTitlePanel="True" />
        <SettingsText Title="List Student" />
        <Images SpriteCssFilePath="~/App_Themes/DevEx/{0}/sprite.css">
            <LoadingPanelOnStatusBar Url="~/App_Themes/DevEx/GridView/StatusBarLoading.gif">
            </LoadingPanelOnStatusBar>
            <LoadingPanel Url="~/App_Themes/DevEx/GridView/Loading.gif">
            </LoadingPanel>
        </Images>
        <ImagesFilterControl>
            <LoadingPanel Url="~/App_Themes/DevEx/GridView/Loading.gif">
            </LoadingPanel>
        </ImagesFilterControl>
        <Styles CssFilePath="~/App_Themes/DevEx/{0}/styles.css" CssPostfix="DevEx">
            <Header ImageSpacing="5px" SortingImageSpacing="5px">
            </Header>
            <LoadingPanel ImageSpacing="5px">
            </LoadingPanel>
        </Styles>
        <StylesEditors ButtonEditCellSpacing="0">
            <ProgressBar Height="21px">
            </ProgressBar>
        </StylesEditors>
    </dx:ASPxGridView>
    <asp:SqlDataSource ID="Main" runat="server" 
        ConnectionString="<%$ ConnectionStrings:Institte_of_Fine_ArtsConnectionString %>" 
        SelectCommand="SELECT * FROM [Student]"></asp:SqlDataSource>
    <dx:ASPxGridViewExporter ID="gridStudent" runat="server" 
        ExportedRowType="Selected" GridViewID="gvwstudent">
    </dx:ASPxGridViewExporter>
    <br />
</asp:Content>

